home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 310 < prev    next >
Unknown  |  1998-01-30  |  777 b 
open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 52 45 53 |CHILD UP|DATE RES|
|00000010| 54 52 49 43 54 00 20 20 | 2f 2a 20 45 52 77 69 6e |TRICT.  |/* ERwin|
|00000020| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00000030| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00000040| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000050| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000060| 55 50 44 41 54 45 20 52 | 45 53 54 52 49 43 54 20 |UPDATE R|ESTRICT |
|00000070| 2a 2f 0d 0a 20 20 69 66 | 0d 0a 20 20 20 20 2f 2a |*/..  if|..    /*|
|00000080| 20 25 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %%Child|FK(" or"|
|00000090| 2c 75 70 64 61 74 65 29 | 20 2a 2f 0d 0a 20 20 20 |,update)| */..   |
|000000a0| 20 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c | %ChildF|K(" or",|
|000000b0| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|.  begin|
|000000c0| 0d 0a 20 20 20 20 73 65 | 6c 65 63 74 20 40 6e 75 |..    se|lect @nu|
|000000d0| 6c 6c 63 6e 74 20 3d 20 | 30 0d 0a 20 20 20 20 73 |llcnt = |0..    s|
|000000e0| 65 6c 65 63 74 20 40 76 | 61 6c 69 64 63 6e 74 20 |elect @v|alidcnt |
|000000f0| 3d 20 63 6f 75 6e 74 28 | 2a 29 0d 0a 20 20 20 20 |= count(|*)..    |
|00000100| 20 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 2c |  from i|nserted,|
|00000110| 25 50 61 72 65 6e 74 0d | 0a 20 20 20 20 20 20 20 |%Parent.|.       |
|00000120| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..|        |
|00000130| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 |  /* %%J|oinFKPK(|
|00000140| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|00000150| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */..  |        |
|00000160| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|00000170| 65 64 2c 25 50 61 72 65 | 6e 74 29 0d 0a 20 20 20 |ed,%Pare|nt)..   |
|00000180| 20 2f 2a 20 25 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 | /* %%No|tnullFK(|
|00000190| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|000001a0| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|000001b0| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|000001c0| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|000001d0| 65 72 65 22 2c 22 20 61 | 6e 64 22 29 20 2a 2f 0d |ere"," a|nd") */.|
|000001e0| 0a 20 20 20 20 25 4e 6f | 74 6e 75 6c 6c 46 4b 28 |.    %No|tnullFK(|
|000001f0| 69 6e 73 65 72 74 65 64 | 2c 22 20 69 73 20 6e 75 |inserted|," is nu|
|00000200| 6c 6c 22 2c 22 73 65 6c | 65 63 74 20 40 6e 75 6c |ll","sel|ect @nul|
|00000210| 6c 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 20 |lcnt = c|ount(*) |
|00000220| 66 72 6f 6d 20 69 6e 73 | 65 72 74 65 64 20 77 68 |from ins|erted wh|
|00000230| 65 72 65 22 2c 22 20 61 | 6e 64 22 29 0d 0a 20 20 |ere"," a|nd")..  |
|00000240| 20 20 69 66 20 40 76 61 | 6c 69 64 63 6e 74 20 2b |  if @va|lidcnt +|
|00000250| 20 40 6e 75 6c 6c 63 6e | 74 20 21 3d 20 40 6e 75 | @nullcn|t != @nu|
|00000260| 6d 72 6f 77 73 0d 0a 20 | 20 20 20 62 65 67 69 6e |mrows.. |   begin|
|00000270| 0d 0a 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 40 |..      |select @|
|00000280| 65 72 72 6e 6f 20 20 3d | 20 33 30 30 30 37 2c 0d |errno  =| 30007,.|
|00000290| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |.       |      @e|
|000002a0| 72 72 6d 73 67 20 3d 20 | 27 43 61 6e 6e 6f 74 20 |rrmsg = |'Cannot |
|000002b0| 55 50 44 41 54 45 20 22 | 25 43 68 69 6c 64 22 20 |UPDATE "|%Child" |
|000002c0| 62 65 63 61 75 73 65 20 | 22 25 50 61 72 65 6e 74 |because |"%Parent|
|000002d0| 22 20 64 6f 65 73 20 6e | 6f 74 20 65 78 69 73 74 |" does n|ot exist|
|000002e0| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'..    |  goto e|
|000002f0| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 20 |rror..  |  end.. |
|00000300| 20 65 6e 64 0d 0a 00 1c | 27                      | end....|'       |
+--------+-------------------------+-------------------------+--------+--------+